<?php
/**
 * @TABLE "pet"
 * @JOIN_TO "id > content_has_pet.pet_id"
 * @JOIN_FROM "pet_breed_id < pet_breed.id"
 * @JOIN_FROM "user_id < user.id"
 * @JOIN_TO "id > pet_featured.pet_id"
 * @JOIN_TO "id > pet_like.pet_id"
 */
class BasePet extends Abstract_PluginEntityManager_Entity
{
	/**
	 * @PRIMARY
	 * @COLUMN "id"
	 * @TYPE "int"
	 * @LENGTH "10"
	 * @NOT_NULL
	 * @AUTO_INCREMENT
	 */
	public $id;

	/**
	 * @COLUMN "user_id"
	 * @TYPE "int"
	 * @LENGTH "10"
	 * @NOT_NULL
	 */
	public $user_id;

	/**
	 * @COLUMN "type"
	 * @TYPE "enum"
	 * @LENGTH "'cat','dog','other'"
	 * @NOT_NULL
	 */
	public $type;

	/**
	 * @COLUMN "pet_breed_id"
	 * @TYPE "int"
	 * @LENGTH "10"
	 */
	public $pet_breed_id;

	/**
	 * @COLUMN "name"
	 * @TYPE "varchar"
	 * @LENGTH "64"
	 * @NOT_NULL
	 */
	public $name;

	/**
	 * @COLUMN "name_url"
	 * @TYPE "varchar"
	 * @LENGTH "64"
	 * @NOT_NULL
	 */
	public $name_url;

	/**
	 * @COLUMN "description"
	 * @TYPE "varchar"
	 * @LENGTH "512"
	 */
	public $description;

	/**
	 * @COLUMN "size"
	 * @TYPE "enum"
	 * @LENGTH "'S','M','L','U'"
	 * @DEFAULT "U"
	 */
	public $size;

	/**
	 * @COLUMN "sex"
	 * @TYPE "enum"
	 * @LENGTH "'M','F'"
	 * @NOT_NULL
	 */
	public $sex;

	/**
	 * @COLUMN "birthday"
	 * @TYPE "timestamp"
	 */
	public $birthday;

	/**
	 * @COLUMN "avatar"
	 * @TYPE "varchar"
	 * @LENGTH "255"
	 */
	public $avatar;

	/**
	 * @COLUMN "like_count"
	 * @TYPE "int"
	 * @LENGTH "11"
	 * @NOT_NULL
	 * @DEFAULT "0"
	 */
	public $like_count;

	/**
	 * @COLUMN "view_count"
	 * @TYPE "int"
	 * @LENGTH "11"
	 * @NOT_NULL
	 * @DEFAULT "0"
	 */
	public $view_count;

	/**
	 * @COLUMN "date_added"
	 * @TYPE "timestamp"
	 * @NOT_NULL
	 * @DEFAULT "CURRENT_TIMESTAMP"
	 */
	public $date_added;

	/**
	 * @COLUMN "status"
	 * @TYPE "enum"
	 * @LENGTH "'visible','deleted'"
	 * @NOT_NULL
	 * @DEFAULT "visible"
	 */
	public $status;

	/**
	 * @COLUMN "user_ip"
	 * @TYPE "varchar"
	 * @LENGTH "40"
	 * @NOT_NULL
	 */
	public $user_ip;
}
?>